Creating Visual Cards: Deaths Per Mth, %MoM, %YoY and Refreshed Date 14
Adding Visual card for: Deaths Per Mth, %MoM, %YoY and Refreshed Date
Steps1
Adding Visual card for Deaths Per Mth
·
Open
Visualization Pane
·
Select
Visual Card
·
Drag
the visual to the dashboard.
·
Click
on "Death Per Mth" From All Measure and drag it into the fields.
·
General:
X - Position = 21, Y - Position = 219, Width = 200, Height = 115
·
Data
Label: Color = #00000, Value Decimal = 0, Font Size = 27, Font type
= DIN
·
Category
= OFF
·
Title
= ON, Text Title = " Deaths Per Mth ", Font Color = #000000 ,
Background Color = #cccccc , Font Size = 17 and Font Family = Segoe
UI Bold, Alignment = Center
· Background ON, Color = #ffffff, Transparency = 0
Stepes2
Adding Visual
card for %MoM
·
Open
Visualization Pane
·
Select
Visual Card
·
Drag
the visual to the dashboard.
·
Click
on %MoM from All Measure and drag it into the fields.
·
General:
X - Position = 21, Y - Position = 352, Width = 200, Height = 115
·
Data
Label: Color = #33DBFF, Font Size = 25, Font type = DIN
·
Category
= OFF
·
Title
= ON, Text Title = " %MoM ", Font Color = #FFFFF, Background Color =
#00000, Font Size = 17 and Font Family = DIN, Alignment = Center
· Background ON, Color = #FFFFF, Transparency = 0
Stepes3
Adding Visual
card for %YOY
·
Open
Visualization Pane
·
Select
Visual Card
·
Drag
the visual to the dashboard.
·
Click
on %YoY from All Measure and drag it into the fields.
·
General:
X - Position = 21, Y - Position = 480, Width = 200, Height = 115
·
Data
Label: Color = #E1A204, Font Size = 25, Font type = DIN
·
Category
= OFF
·
Title
= ON, Text Title = " %YoY ", Font Color = #FFFFF, Background Color =
#00000, Font Size = 17 and Font Family = DIN, Alignment = Center
·
Background
ON, Color = #FFFFF, Transparency = 0
Steps4
How to create Refresh Date:
2. 2. Click New sources on left corner
3. 3. Click Blank Query
4. 4. Enter =DateTime.LocalNow() & press enter
5. 5. Rename Queryn1 by Date Refresh
6. 6. Convert to Table Format
7. 7. Rename Column1 by DateTime
8. 8. Go to Transform and Date choose Date only
9. 9. Duplicate DateTime and rename it Time and under Time choose Time only
Step4b: Adding Refreshed Date
·
Open Visualization Pane
·
Select Visual Card
·
Drag the visual to the dashboard.
·
Click on refreshed date from Data Refresh Table and place it
inside the fields.
·
General: X - Position = 21, Y - Position =604, Width = 200,
Height = 100
·
Data Label: Color = #00000, Font Size = 15, Font type = DIN
· Category = OFF
· Title ON, Text Title = " Refreshed Date", Font Color = #FFFFF, Background Color = #00000 , Font Size = 17 and Font Family = DIN
How to Create a Card in Power BI
https://www.tutorialgateway.org/create-a-card-in-power-bi/